December 19, 2008 at 11:39 am
How do I backup a database to 4 devices, on 2 different disks as there is not enough space on a single drive to create a single full backuo file. I created four devices two each on two separate disks and gave to command as
Use master
go
BACKUP DATABASE [DCPPQTR] TO [DSBK1], [DSBK2], [DSBK3], [DSBK4] WITH INIT , NOUNLOAD , NAME = N'WesternSouthern backup', NOSKIP , STATS = 10, NOFORMAT
go
This is a SQL 7 server and the version is 1063.
When the job is run, it is backing up to one disk completely and the job fails as it is not backing up to all four devices. Looks like it is creating a single backup file..any suggestions?
Thanks in advance!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 19, 2008 at 2:56 pm
Were striped backups supported in v7?
I've never used devices for this. I'd use disk files only, not devices.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 19, 2008 at 5:30 pm
looks like sql 7 doesn't support device backups..i tried time and again but its copying only to a single file. I believe i ll have to have a dedicated disk with the space required for this backup
Its about time we upgrade this server..is it possible to go to SQL 2008 from SQL 7?
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 22, 2008 at 12:05 pm
The_SQL_DBA (12/19/2008)
looks like sql 7 doesn't support device backups..i tried time and again but its copying only to a single file. I believe i ll have to have a dedicated disk with the space required for this backupIts about time we upgrade this server..is it possible to go to SQL 2008 from SQL 7?
Thanks!!
I don't think so, general rule is 2 versions back (so 2000/2005 can upgrade to 2008, 7.0/2000 can upgrade to 2005)
There are currently 2 versions of SQL Server Upgrade Assistant: the SSUA 2005 version supports upgrades from both SQL Server 7.0 and 2000 to 2008 and the SSUA 2008 version supports upgrades from SQL Server 2000 and 2005 to 2008.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply