Comments
Sort by recent activity
Here is the full script I am running:
master..sqlbackup 'sql "restore database [hchb_hha_20060529rd] from disk =
''\\lounas01\sqlbackups\hchb_hha\HCHB_HHA_PSQL0305_(local)_FULL_20060527_00.sqb'' with NOrecovery,
move ''HCHB_TSCH_Data'' to ''G:\Program Files\Microsoft SQL Server\MSSQL\Data\hchb_hha20060529rd2.mdf'',
move ''HCHB_TSCH_log'' to ''h:\Program Files\Microsoft SQL Server\MSSQL\Data\hchb_hha20060529rdlog2.ldf''"'
master..sqlbackup 'sql "restore database hchb_hha_20060529rd from disk =
''\\lounas01\sqlbackups\hchb_hha\HCHB_HHA_PSQL0305_(local)_DIFF_20060529_00.sqb'' with norecovery "'
master..sqlbackup 'sql "restore log hchb_hha_20060529rd from disk =
''\\lounas01\sqlbackups\hchb_hha\HCHB_HHA_PSQL0305_(local)_LOG_20060529_03.sqb'' with norecovery"'
master..sqlbackup 'sql "restore log hchb_hha_20060529rd from disk =
''\\lounas01\sqlbackups\hchb_hha\HCHB_HHA_PSQL0305_(local)_LOG_20060529_05.sqb'' with norecovery"'
master..sqlbackup 'sql "restore log hchb_hha_20060529rd from disk =
''\\lounas01\sqlbackups\hchb_hha\HCHB_HHA_PSQL0305_(local)_LOG_20060529_07.sqb'' with norecovery"'
master..sqlbackup 'sql "restore log hchb_hha_20060529rd from disk =
''\\lounas01\sqlbackups\hchb_hha\HCHB_HHA_PSQL0305_(local)_LOG_20060529_09.sqb'' with norecovery"'
master..sqlbackup 'sql "restore log hchb_hha_20060529rd from disk =
''\\lounas01\sqlbackups\hchb_hha\HCHB_HHA_PSQL0305_(local)_LOG_20060529_11.sqb'' with norecovery"'
master..sqlbackup 'sql "restore log hchb_hha_20060529rd from disk =
''\\lounas01\sqlbackups\hchb_hha\HCHB_HHA_PSQL0305_(local)_LOG_20060529_13.sqb '' with recovery,
stopat = ''May 29 2006 12:05PM'' "' / comments
Here is the full script I am running:
master..sqlbackup 'sql "restore database [hchb_hha_20060529rd] from disk =
''\\lounas01\sqlbackups\hchb_hha\HCHB_HHA_PSQL0305_(local)_FULL_20060527_00.sqb'' w...
Can you give more detail? What is the filelist? What file name do i need to supply? What does this command do?
I looked in the help document and it doesn't give any detail. / comments
Can you give more detail? What is the filelist? What file name do i need to supply? What does this command do?
I looked in the help document and it doesn't give any detail.
When I look at the extended store proc in master, the path listed is xpstar.dll. / comments
When I look at the extended store proc in master, the path listed is xpstar.dll.
yes, they are sorted. / comments
yes, they are sorted.
The results are not sorted using this query. / comments
The results are not sorted using this query.
128 char limit is pretty restrictive. I get the error on every server. When is the patch for this due? / comments
128 char limit is pretty restrictive. I get the error on every server. When is the patch for this due?
When i look at the properties of the extended stored proc it tells me the path is - C:\Program Files\Red Gate\SQL Backup\xp_sqlbackup.dll
but when i look on my machine, the path is - C:\Program Files\Red Gate\SQL Backup\(LOCAL)
the xp_sqlbackup.dll is version 4.0.0.113 / comments
When i look at the properties of the extended stored proc it tells me the path is - C:\Program Files\Red Gate\SQL Backup\xp_sqlbackup.dll
but when i look on my machine, the path is - C:\Program Fi...
When i run sqlbackup, i get:
Msg 20001, Level 1, State 20001
Error executing extended stored procedure: Invalid # of Parameters / comments
When i run sqlbackup, i get:
Msg 20001, Level 1, State 20001
Error executing extended stored procedure: Invalid # of Parameters
output from sql backup 3.2.0
error: cannot find sql backup command line executable. registry information is not correct. / comments
output from sql backup 3.2.0
error: cannot find sql backup command line executable. registry information is not correct.
ver 3.1.0.1
Yes, I'm using the GUI. / comments
ver 3.1.0.1
Yes, I'm using the GUI.