Viewing 15 posts - 301 through 315 (of 341 total)
To quickly check if you have rights, run xp_cmdshell 'dir \\remotesharedfolder'.
September 9, 2004 at 7:24 pm
Did you actually manage to restore the cold backups, and apply trx logs to the database after that? As regards the space constraints, have a look at our product, MiniSQLBackup. ...
September 7, 2004 at 11:13 am
I do not think it's possible to restore log files to a database you restore from a cold backup.
Firstly, the database needs to be in standby/restoring mode if you want...
September 6, 2004 at 7:15 pm
Are you able to use the newly restored database? If you run DBCC CHECKDB, do you find any errors? Check this link to see if it's applicable to your...
September 6, 2004 at 2:37 am
That's entirely up to you to implement on the client side. SQL Server will just provide you the backup data in the form of memory buffers. You decide what you...
September 6, 2004 at 2:35 am
If it even fails when running manually, I think there is definitely something wrong with the remote folder permissions. See if you can query the contents of the remote folders...
September 5, 2004 at 8:06 pm
You need not concern yourself with the server side. On the Overview page, note the phrase:
The server side interface is described for informational purposes only. This interface is used exclusively by...
September 5, 2004 at 8:01 pm
Did you change the location of the data/log files on the originating server between the time you performed the initial full database backup and the subsequent log backups?
September 4, 2004 at 10:01 am
Have you tried performing a backup using Query Analyzer first, to the remote destination folders?
September 4, 2004 at 9:56 am
I take it you are trying to backup to a remote folder, and that you are encountering errors when trying to perform the backup? Ensure that the SQL Server service...
September 3, 2004 at 9:50 am
Could you pls post the error messages you are receiving?
September 3, 2004 at 2:47 am
For anyone that's interested, I've described in a little more detail the Microsoft VDI for third party backup software vendors here.
September 3, 2004 at 2:46 am
INSERT, UPDATE, or DELETE statements are allowed during a backup operation. One suggestion to ensure consistency across databases for the backups is to set all databases to single user mode...
September 1, 2004 at 10:42 am
In Inside SQL Server 2000, the section on backups implies that the backup data is the state of the database when the backup ends, not at the beginning as that stated...
August 31, 2004 at 9:26 am
I'm guessing it's a rights problem. In Query Analyzer, what is the result when you run this:
master..xp_cmdshell 'dir \\sourceserver\logshare'
If you get the 'Access denied' message, change the service startup...
August 25, 2004 at 1:14 am
Viewing 15 posts - 301 through 315 (of 341 total)