Activity overview
Latest activity by rdalton
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...
stopat question
I'm doing a point in time restore using version 4.1. I'm using the command line. I have the stopat = 12:05pm but there are records in the database with a timestamp of 12:14pm. How is this possible?
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.
yes, they are sorted. / comments
yes, they are sorted.
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.
The results are not sorted using this query. / comments
The results are not sorted using this query.
Error: Failed to read file list from backup file.
I'm running ver 4.1. I'm trying to restore a ver.3 backup. I'm using the wizard. As soon as 'step 3 of 4' screen comes up, a pop up box appears with this error.
What does this mean? How can I g...
File list display
When I view directories or files, they are not in alphabetical order. I can't find any way to make them order differently.
I'm on ver 4.1
Check for updates (from Help menu only) gives an error.
How do i get the 4.1 update?
When I try to say 'check for updates' I get a message 'The update service does not recognize this product Error 13000: Product Not registerd with the agent.'
I'm not ...
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?