Comments
Sort by recent activity
So help me here. I'm a SQL dummy. I read that when you MOVE a SQL database you need to move the MASTER and MSDB database along with it? It that true? Any other databases?
If so, then I only moved the MSDB, what about the MASTER? If I do need to move the master, should I just use QUERY ANALYZER, go into SINGLE USER mode, then use RED-GATE to restore?
Thanks
George / comments
So help me here. I'm a SQL dummy. I read that when you MOVE a SQL database you need to move the MASTER and MSDB database along with it? It that true? Any other databases?
If so, then I only mov...
I never restored the MASTER and MSDB database from the real server to this one, i guess i need to, right? Do i need to restore any of the others (temp, pub, etc.) when moving the actual database to a new server? I did the MSDB sucessfully, but the master errors out. Don't I need to do that one too (btw, i'm using red-gate to this too). I'm running the restore currently on the big one now to see if restoring the MSDB from the main server to the new one fixed the issue. / comments
I never restored the MASTER and MSDB database from the real server to this one, i guess i need to, right? Do i need to restore any of the others (temp, pub, etc.) when moving the actual database to...
1) MSDB restored OK
2) the main database now WORKS great during the restore!
3) MASTER FAILS (info below)
RESTORE failed. VDI error 1010:failed to get configuration from server. check that the sql server instance is running, and that you have the SQL server systems administrator server role. Error Code: -2139684861 (The api was waiting and the timeout interval had elapsed.) / comments
1) MSDB restored OK
2) the main database now WORKS great during the restore!
3) MASTER FAILS (info below)
RESTORE failed. VDI error 1010:failed to get configuration from server. check that the sql ...
Peter,
I am not very good with SQL or SQL commands. Can you please be PRECISE and let me know what to do step by step. Do you work for RED-GATE? If so, please email me the exact directions. Can you email me and I'll let you know our # so you can call me direct. Why is this happening?
Thanks,
George / comments
Peter,
I am not very good with SQL or SQL commands. Can you please be PRECISE and let me know what to do step by step. Do you work for RED-GATE? If so, please email me the exact directions. Can...
Server: Msg 7995, Level 16, State 1, Line 1
Database 'msdb' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing.
DBCC execution completed. If DBCC printed error messages, contact your system administrator. / comments
Server: Msg 7995, Level 16, State 1, Line 1
Database 'msdb' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing.
DBCC execution completed. If DB...
This is just a new disaster server. Anyway to wipe the MSDB database and start over? / comments
This is just a new disaster server. Anyway to wipe the MSDB database and start over?
backup restore works just fine using the enterprise manager maintenance job WITHOUT Red-gate script.
and the servers restoring too are brand new dell drives....this is not good, as we've been using red-gate backup for months (full backup nightly, and 10 minute backup logs daily). / comments
backup restore works just fine using the enterprise manager maintenance job WITHOUT Red-gate script.
and the servers restoring too are brand new dell drives....this is not good, as we've been using...
why are the errors showing
Microsoft SQL Server\MSSQL\data\msdbdata.mdf'
when we are restoring to a database called
imageright.mdf, not msdbdata.mdf / comments
why are the errors showing
Microsoft SQL Server\MSSQL\data\msdbdata.mdf'
when we are restoring to a database called
imageright.mdf, not msdbdata.mdf
not sure what u mean by bad page, but we cant restore any backup made by redgate via enterprise manager backup script jobs. we get the same error. please help / comments
not sure what u mean by bad page, but we cant restore any backup made by redgate via enterprise manager backup script jobs. we get the same error. please help