July 3, 2014 at 12:30 pm
Hi all:
Yes-your eyes are not failing you-my client has a SQL 6.5 instance for databases that have not been backed up in a while. I have to initiate a backup strategy and was wondering if anyone could provide the T-SQL for backing up a database. I've looked online a number of different ways and just can't find it. Any help would be greatly appreciated!
TC
July 3, 2014 at 12:38 pm
Disregard-I finally found it. Here's a sample statement:
DUMP DATABASE model
TO DISK = '\\[SERVERNAME]\[FOLDERLOCATION]\model_test.BAK'
WITH INIT
July 3, 2014 at 12:51 pm
Tim Cullen (7/3/2014)
Disregard-I finally found it. Here's a sample statement:DUMP DATABASE model
TO DISK = '\\[SERVERNAME]\[FOLDERLOCATION]\model_test.BAK'
WITH INIT
You may want to set up a "device" to backup to.
NOTE: you MUST MUST MUST document EVERYTHING about the internal device structure of EVERY database on the instance!!! If you don't you can have perfect backups and be COMPLETELY unable to restore them if you needed to! The physical device structures specified start and end points for various data AND log storage in file(s), and without the knowledge of what is where you are dead meat. I had a client early on in my career not know that and when they had to restore once they lost everything. We spent weeks reloading data from 9-track tape. :hehe:
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 11, 2014 at 11:53 am
One additional note when dumping to devices in v6.5.
You can specify a UNC (i.e. \\servrename\share\etc) when you create the dump device.
However unless your network is as fast as lightening it will fail and worse, create corrupt backups that you mau never know about until you try and restore one !
Local devices are the best choice right after the first choice of 'getting to a much newer, and supportable version', of SQL Server.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply