Viewing 15 posts - 76 through 90 (of 210 total)
I would recommend that instead of using a backup device you backup to a unique filename each night. This way you can purge the older backup files off of disk. ...
November 16, 2005 at 12:53 pm
You could use differential backups to reduce improve the performance of this. Take a full backup every week and restore it into development and then take nightly differentials and apply...
November 1, 2005 at 11:58 am
Why not just run backups of your databases in series rather than in parallel.
BACKUP DATABASE db1 TO DISK=filename1
BACKUP DATABASE db2 TO DISK=filename2
etc...
Its a fairly easy TSQL script to create to...
November 1, 2005 at 11:55 am
I hate to say this but you are probably out of luck. Have you ever taken an image of the hard drive? Maybe you have a system restore point that...
November 1, 2005 at 11:53 am
Do you have AWE enabled on this server. There were several known issues with sp4 and running AWE. If so you should search the microsoft KB for the relevant hot...
October 7, 2005 at 2:28 pm
Quest Central for SQL Server from Quest Software has a component called Performance Analysis that does exactly this.
October 5, 2005 at 11:47 am
We're hoping that it will get activated in a service pack. Fingers crossed.
September 16, 2005 at 4:21 pm
Yes,
You do need a copy of SQL Server on the witness server. The good news is that this copy can be SQL Express (the MSDE of SQL 2005) which is...
September 15, 2005 at 8:40 am
1) Take a backup of pubs and include the password clause.
2) Open the backup file in notepad.
3) Do search for the string "Smith"
4) Take a look...
September 14, 2005 at 2:14 pm
Especially dissapointing as microsoft had been advertising the june CTP as feature complete. I to had given 20+ presentations on mirroring in the past two months... looks like I'll...
September 14, 2005 at 2:03 pm
My statement regarding refreshing development databases was meant to suggest that the data that is being developed against is current. Assuming no schema changes have occured, a restore is...
August 9, 2005 at 4:11 pm
Also, network backups are very slow and tend to saturate even the largest networks. Best practices recommend that you backup up your databases locally and then copy them to your...
August 5, 2005 at 11:48 am
The best method for this is to take a backup of your development database and restore the backup file into production.
August 3, 2005 at 7:15 am
If you are doing a restore and re-initializing the data files (using a with move statement) the first thing the restore does is initialize the data files (marking extents and...
August 3, 2005 at 7:11 am
I'd like to reiterate what Chris said. PASS is the largest and best conference dedicated to SQL Server. This year should be especially exceptional with the upcoming release...
August 2, 2005 at 9:15 pm
Viewing 15 posts - 76 through 90 (of 210 total)