Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

need backup strategy Expand / Collapse
Posted Monday, March 30, 2009 12:23 PM

SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, March 29, 2016 10:39 AM
Points: 942, Visits: 1,089
Thanks guys .

Urg yaa 6.5 is nightmare but I have to support 2 Production and 1 Dev/Test install of 6.5. Heh you can backup directly to file in 6.5 but for some reason I keep running into issues when I restore.

When I backup to the Device I get a backup that is 100+MB, same database when "dump" to the file goes to only 10MB file. So when I restored the database on other server it cased way too much grief. So I just do Device Backups/Restores; even though it is annoying heh.



Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN.
Microsoft FTE - SQL Server PFE

* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing.

How to ask for help .. Read Best Practices here.
Post #686370
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse