Viewing 15 posts - 481 through 495 (of 534 total)
As it turns out. I reattached the Model and msdb in the wrong order!!!!!!
when detaching and reattaching model and msdb - the model DB needs to be reattched BEFORE the...
October 31, 2005 at 12:54 pm
No, I have not touched the Master DB. I only performed these steps:
added -T3608 to SQL Server startup parameters and restarted sql server.
detached Model and msdb, moved data and...
October 31, 2005 at 10:36 am
Thank you. I do have plenty of free space on the drive so i should be all set.
October 31, 2005 at 7:14 am
Thanks one and all. and I hear ya about rebooting after installations or sp applications.. What I ended up doing was this:
Installation of the second named instance...
checked to...
October 27, 2005 at 10:36 am
Thank you!!! Sounds like I can even install the Second Instance without disrupting the first??? I didn't want to have to do this after-hours!!!
October 26, 2005 at 8:18 am
in addition to being sure that the account running SQL Server Services are being started with a Domain Account that has write permissions to the Network Drive/device, You'll have to use...
October 26, 2005 at 7:54 am
Now I'll just have to figure out how to get them copied off to another Server and restored periodically... yikes!
October 24, 2005 at 6:06 am
What I did was make another maintenance plan.... It backs up my DBs to a Network Drive at 8pm every night. Then at 5am i do another full set of...
October 24, 2005 at 6:04 am
Thank you for the response.. One more question.. Considering that I use SQL Server Maintenance Plans for my Backups, How can I do transaction log backups to my local server...
October 21, 2005 at 10:24 am
Sure. I use Backup/Restore, but I think dettach/attach will work too. here's a link that will be helpfull if you have any users to move: http://support.microsoft.com/kb/246133
September 23, 2005 at 2:15 pm
September 22, 2005 at 12:08 pm
http://support.microsoft.com/kb/246133
Check out this link too. sp_helprevlogin works great for re-creating users on a different Instance with the same SID and password !!!
September 12, 2005 at 1:13 pm
That's what I'm asking.. if I add a row to a table that is called by a view.. so I have to also drop and recreate the view????
September 8, 2005 at 10:02 am
I tried that.. actually I tried filtering on DatabaseName because DatabaseID requires a numberic value and I don't know what that is. When I filtered on DatabaseName, it returned ALL Database...
June 24, 2005 at 12:27 pm
Viewing 15 posts - 481 through 495 (of 534 total)