How SQL SERVER 2005 Backup && ArcServe Backup Coexist ??
Apr 15, 2008
I have only one tape drive.
My server is using the SQL server 2005 backup tool and arcserve backup tool to backup different files .
Everytime I need to disable and enable the tape device driver (in device manager /windows) before I can use SQL server 2005 backup tool.
Everytime I need to disable and enable the tape device driver (in device manager /windows) before I can use arcserve backup tool.
It seems that the tape device resource is held by softwares even the tape drive is not in use.
What should I do to make the tape drive shared by different softwares?
Regards,
Manuel
View 2 Replies
ADVERTISEMENT
Aug 7, 1998
This seems to happen just after our backups run. the result is that the SQL Server
Enterprise Manager can be brought up the next day but nothing can be accessed or
inquired of. The service is still running, the server is still up and rebooting the server
resolves the problem.
98/08/06 20:32:31.68 kernel dpdb_asyncread: mirror: Operating system error 6
(The handle is invalid.) encountered
Is anybody else using Arcserve Backup Agent for SQL Server for Windows NT, RAID 5?
Have you seen this? I`ve been to MS home page and on technet. No mention of this
problem. Next stop is Arcserve home page, if they have one. I have read the error logs
and this is the second time this has happened this week. Both times since we added
Arcserve to manage our MS SQL Server Database backups.
Best Regards and Thanks for your time.
View 1 Replies
View Related
Jan 21, 1999
Any thoughts or experiences (good or bad) on using the SQL agents from Arcserve or BackupExec for backups as opposed to standard dumps to disk?
I have always used dumps and taken the position that these tools work well, reliably and do not depend on another device ( tape device) for backups. Also they should be quicker and not cause any problem with table / log concurrency or delays in updates while the backup takes place.
Also, does anyone know how these products actualy maintain concurrency? Has anyone ever used one of these backups as a recovery?
Thanks in advance.
View 1 Replies
View Related
Dec 5, 2006
What is the difference between "Files aned File Groups" backup and Partial Backup?
Looks like both are same.. Please comment.
View 3 Replies
View Related
Jan 31, 2008
Hi there
I'm getting this message on my third automated backup of the transaction logs of the day. Both databases are in full recovery mode, both successfully backed up at 01.00. The transaction logs backed up perfectly happily at 01:30 and 05:30, but failed at 09:30.
The only difference between 05:30 and 09:30's backups is that the log files were shrunk at 08:15 (the databases in question are the ones that sit under ILM2007, and keeping the log files small keeps the system running better).
Is it possible that shrinking the log files causes the database to think that there hasn't been a full database backup?
Thanks
Jane
View 3 Replies
View Related
Feb 18, 2015
SQL Server 2008 r2 - 6 GB memory...I attempted a backup on a 500GB database but it was taking way too long. I checked the resources on the box and saw the CPU at 100%. I checked the SQL Server activity log and saw a hung query (user was not even logged on) that had multiple threads so I killed it and now the CPU utilization is back to normal.
Trouble is, now all of the threads in the activity monitor for the backup show 'suspended' and the backup appears to be not doing anything.
View 3 Replies
View Related
Aug 3, 2015
Need to restore database,here's the scenario:
Data got deleted on Friday evening, need to have database restored to FRiday afternoon and also some data has been entered on Monday, which needs to be there.
View 8 Replies
View Related
Dec 28, 2007
Windows 2003 backup utility uses the shadow copy option that allows it to copy open files.
Therefore, can I use this utility to backup the .mdf and .ldf files for my SQL 2000 database?
I can then attach the .mdf files if I need to restore the database to another server.
Can anyone tell me if this is safe? I've tried it and it worked but I'm worried there maybe some lurking danger in using this approach.
View 4 Replies
View Related
Mar 13, 2015
I've written a custom script to delete backup files from location. But unable to modify now to count the number of files are deleted. How to modify the script...
/* Script to delete older than N days backup from a specific directory */
USE [db_admin]
GO
IF OBJECT_ID('usp_DeleteBackup', 'P') IS NOT NULL
DROP PROC usp_DeleteBackup
GO
[Code] .....
View 2 Replies
View Related
Nov 29, 2001
I want to know how people are backup up their win2k system and SQL 2000 server. If you want a run backup once a night and first backup win2k file system and then run backup using sql agent will that work?
Thanks.
View 2 Replies
View Related
Oct 2, 2001
SQL 7.0 SP1.
We do SQL Server backup and also third part backup (with SQL agent active) of SQL Server databases.
Sometimes happen this situation:
01.00 SQL Server backup of DB1
01.00 third part backup of DB1
02.00 SQL Server T-LOG backup of DB1
03.00 SQL Server T-LOG backup of DB1
03.30 SQL Server differnatial DB backup of DB1
04.00 SQL Server T-LOG backup of DB1
or this situation:
01.00 SQL Server backup of DB1
02.00 SQL Server T-LOG backup of DB1
03.00 SQL Server T-LOG backup of DB1
03.10 third part backup of DB1
03.30 SQL Server differnatial DB backup of DB1
04.00 SQL Server T-LOG backup of DB1
My questions now are:
Are my SQL Server backups valid (DB,Differenatial and T-LOG)?
In case of a restore operation, can I use my SQL Server backups without problem?
In other words, can we leave the third part backup tool active or it should be taken away?
Can anybody clarify this for me?
Thank you in advance.
Franco
View 1 Replies
View Related
Jul 26, 2006
I read in the installation requirements document for SQL Server 2005 Express the section on upgrading MSDE to SQL Server 2005 Express. The section indicated that if MSDE is installed via an application installation, that application will have to be uninstalled to remove MSDE. This leads to my question.
The small application I'm looking into developing will require SQL Server 2005 Express. What if a customer is using an application that installed MSDE? Can the two products coexist without problems?
Thanks!!
View 1 Replies
View Related
May 22, 2007
I have SQL server 7 installed and running ok. Can I install express server? The idea is to have two different databases for different applications, each running in each sql.
View 1 Replies
View Related
Feb 3, 2006
Can SQL Server 2005 Express coexist with SQL Server 2005 developer edition on the same PC?
View 6 Replies
View Related
Jan 4, 2008
Not sure if this was posted but having a hard time finding an answer.
I'm currently running sql server 2000 enterprise edition on my machine and was wondering what would happen if i installed 2005 express edition and vice versa? I've found many blogs and post about compatibility issues with the 2005 Express Beta version but couldn't find any news with full version. It would be much appreciated if someone can help me out with this problem.
Thanks!
View 1 Replies
View Related
Jul 29, 2007
hi-i want to create automatic Backup scheduler for my sql-server 2005 how can i create sql-server2005 backup scheduler
thanks
View 2 Replies
View Related
Jun 4, 2007
Hi,
I created a job to backup my database. Sometimes I get the following error:
The job failed. Unable to determine if the owner (DOMAINAdministrator) of job Backup.Subplan_1 has server access (reason: Could not obtain information about Windows NT group/user 'DOMAINAdministrator'<c/> error code 0x54b. [SQLSTATE 42000] (Error 15404))
I already deleted the job and made it again. Same problem. I don't get that error every day. For example: I got it 4 times last month.
Does anybody know what I can do to resolve the error?
View 1 Replies
View Related
Jan 12, 2006
Is there a way to backup databases within the Sql Server 2005 Manager?
View 1 Replies
View Related
Mar 15, 2007
I have ctreated a maintenance plan to backup a database daily.
The option is set to overwrite.
1)
How is it possible to allow for say four days of backup files to remain but any older backups to be deleted. At present I only get one file which gets overwritten every day.
2)
What does the Append database option do? I know that it increases the backup file size on every backup. Not sure what that does to the file internally. i.e. why doe the file size increase even if there has not been any activity on the database on that day?
Thanks
View 6 Replies
View Related
Sep 13, 2007
Problems with Database Backup.
Want to backup the transactoin log, but I have the failure:
The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE. [SQLSTATE 42000] (Error 4208) BACKUP LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
I set the recovery model to FULL, that worked fine for about six hours. After same failure again. And the recovry model was SIMPLE.
Found this in the Eventlog:
Setting database option RECOVERY to SIMPLE for database
So what can I do? Thanks for your ansers!
Greetz
View 13 Replies
View Related
Oct 2, 2006
I am new to sql server 2005.I am trying to set up databse backup using databse management.but some how it is not working and i am getting error after all settings done.
Can any one have experience on this. plz i am in desperate trouble.
I am thanksful to you in advance.
Thanks,
Bharat.
View 10 Replies
View Related
Jul 11, 2007
Description:
Created a maintenance plan to backup the database.
Scheduled the job to run the maintenance plan.
Backup ran.
No errors.
Restored the database to a new database with different name.
Problem:
One column in one table is not correct.
The column is a smallint. The value for this column in the original database was 1.
The value in the restored database was zero.
Out of 7 database backups, 2 of the backups have this problem, the other 5 backups
restore the column correctly.
View 6 Replies
View Related
Oct 4, 2007
Hi All
I have recently installed the sql server 2005 on my server. I am going to setting up the maintenance plan to backing up my DB on the network.
I can do it locally but i want to backup directly into the shered folder on the network.
Please help me
View 2 Replies
View Related
Oct 5, 2007
I have a community server running in a hiring host, and I also install it on localhost. I would like to know how to backup the database from hosting and restore it to the site running on my localhost so that two sites is the same and in case there is an error from the hosting I can recover my database.
I can connect to my hosting database easily using SQL server Studio 2005, but the hosting does not offer backup through control panel. Could you please instruct me how to backup and restore database by SQL Server Management Studio.
Thank you very much,
View 2 Replies
View Related
Dec 10, 2007
Hi,Good morning to All,
I have SQL Server 2005 installed on my system. Recently I have formatted by computer. But I couldn't take backup of my data. Big loss.
For this, I've googled also. but I couldn't get clear information.
I want like the following:I could able to backup entire the Database either into my pen-drive, or some other media.And, latter I could able to put the Data back into my system.
Can anyone please tell how to take backup of my Data, and Restore also.
Thanks in advance,Ashok kumar.
View 1 Replies
View Related
Feb 18, 2006
hello all
i have Database of having 5 tables , 5 SP, etc
now due to some reason i have to format my Harddisk.
so which files i shuold take as Backup so next time i install Sqlserver 2005 so i will have to run(paste ) only those backuped files and i will have my database ready , pls show me path for taking back up.
thank u
View 3 Replies
View Related
Jun 26, 2007
Hello Friends:
My problem relates to backing up my MS SQL 2005 database which is sitting on a shared server at a hosting company.
OVERVIEW:
- Hosting company is using MS SQL 2005
- I am using the SQL Server Management Studio that comes with SQL Server 2005 Standard (NOT Express), which is installed on MY PC.
- So, I am connecting to the SQL server over the internet
WHAT I WANT TO ACHIEVE:
- I would like to backup the data sitting on the Hosting company's MS SQL Server. I only have one database on this SQL Server. There are of course 100s of other databases on the same server which belong to other customers of the hosting company.
- I want to bring the backup to MY PC, from the SQL Server.
- As far as I can tell the following options within SQL Server Management Studio may be of help to me. I do not know which one I should use or which one is best or what is the proper method. 1) Select Backup option from the Tasks menu (but it only shows me drives/devices on the Hosting SQL Server, not my PC, so I can’t backup to my PC) 2) Export Data (it does not work, showing errors ‘…not a trusted connection…’ I have no clue what a trusted connection is. 3) Copy Database (which is supposed to copy the remote database on the Hosting company SQL server, to my local SQL Server running on my PC). I go through the wizard, on the last screen it just hangs i.e. shows- not responding)
MY QUESTION TO THE COMMUNITY:
How do I backup the database sitting on the hosting company SQL server? I of course need to bring the backup to my PC.
View 5 Replies
View Related
Dec 27, 2007
Morning guys,
What is the equivalent to the taskpad on sql server 2005?
I want to be able to see when the last backup and restore was performed via transact sql ......
how would you go about that..... ?
what would I search... ?
View 2 Replies
View Related
Feb 22, 2007
Hello,
SQL Server 2005 TR with IU/QUS - Restore from a backup
Im trying to set-up the above using sp1. It all works fine until the final step, creating a subscription through sp_addarticle and Im getting the following error:
Msg 8152, Level 16, State 10, Procedure sp_MSget_synctran_commands, Line 198
String or binary data would be truncated.
This worked fine on my laptop with a small table with a couple of columns.Now Ive looked at this error and its like
select * from #art_commands
The table only has 49 columns in it, so its not huge.
What are my options for solving/getting around this problem:
1. Try and fix sp_MSget_synctran_commands, from memory, #art_commands has a nvarchar(max) column and Im wondering if this is related. must admit, havent really looked solidly at this sp yet.
2. SP2 doesnt look like it fixes this problem.
3. Create a bespoke method to replicate.
4. anymore for anymore?
It will be impossible to synchronize the databases so this restore from backup was my only option. Im a bit stuck now, can anyone help?
many thanks,
John P
View 3 Replies
View Related
Feb 6, 2007
May i can schedule backup using Sql Server 2005.
Thanks
View 1 Replies
View Related
Mar 14, 2007
Hi,
In sql server 2005 i have created a maintenance plan to backup a database.
Where do i schedule this backup to run every day please?
Thanks
View 1 Replies
View Related
Oct 31, 2006
Hi, Our Sharepoint of TFS was down a couple of days ago. By luck, we had fully backed up SQL database. Now, the problem is, I uninstalled everything and tried to move TFS to a new server machine on the domain. I installed freshly everything and tried to restore all the databases (with tables also). Now the problems are these:
1 - Since there are lots of different backup-restore procedures telling on the Internet from some forums and this forum also: What should i do basically to make the configuration of Sharepoint and Reporting Services to make them work correctly?
2 - Secondly, even if i fail in the problem above, I, at least, want to save the source control files and sharepoint files. Where can I find them and how can I take them back to my new TFS installation?
3 - If these problems exist and Suppose on a new project on the new installation, i create new WI's, documents (with new Version Control information), and new SPS configuration. And on a new release,the problems are resolved. Is there some way that I can merge the former Backup with the new installation's database?
View 1 Replies
View Related
Mar 21, 2007
Anyone knows how to schedule backup of database in SQL server 2005?
View 10 Replies
View Related
