Wednesday, May 8, 2013

[MS SQL Server] model database won't restore

[MS SQL Server] model database won't restore

model database won't restore

Posted: 08 May 2013 04:28 AM PDT

This is going to be a /facepalm moment I just know it as I'm sure I'm making a schoolboy error (repeatedly).Fortunately I'm not in a full DR situation, but was training one of my juniors through the process in case I ever have to talk him through it remotely, and I have hit a problem I have never encountered before.My setup is SQL Server 2008 SP2 running on a Windows 2008 server.Now my DR documentation and processes have always demanded that the Network team rebuild me a server with the same drive configuration as the server that has curled up it's toes - mainly because it makes my life so much easier. However for this training session they set the server up for me but I forgot to send them the drive configuration, and as a result got back different drive letters. I know I can easily get them changed, but though this would be a good example of what happens in this situation; it wasn't documented in our procedures, it had never happened to us before, but it could.The build went okay, I trained through moving the system databases, altering the startup parameters, keeping a copy of the system databases in case something went wrong and we had to reset and start again, etc. No problems so far, and then things went pear shaped.We restored the master database from another server with no issues, started the server up with the T3608 switch so we could alter the tempdb location and those of the model and msdb databases as the new master had them on drive letters that didn't exist.We hit the usual catch-22 situation that it couldn't start the tempdb because the model database was missing, and wouldn't allow the model to be restored without the tempdb (being created by the model, which didn't exist, etc.) T3609 to allow it to use the existing tempdb data files and we got over that one.So now we have the newly restored master, the original model, msdb and tempdb files, a server that would start fine, and we needed to restore the model and msdbThis is the command I issued:RESTORE DATABASE model FROM DISK='?:?????????.bak' WITH REPLACEWe were immediately greeted with the error that it couldn't restore the mdf or ldf files as they were pointing to the old locations of the old server. Although the model database was in it's new location and the master knew this (SQL Server would start and run normally even without the user databases present), the restore was trying to restore the databases to their original location from the old server. So I went for the obvious:RESTORE DATABASE model FROM DISK='?:?????????.bak' WITH FILE=1, MOVE 'modeldev' TO '?:?????????\model.mdf', MOVE 'modellog' TO '?:??????\modellog.ldf', NORECOVERY, NOUNLOAD, STATS=10The message now is that I can't move a system database with RESTORE.I've tried Google, MSDN and TechNet and can't find anything to help, so I must be doing something really basically wrong, but I've gotten myself into so much of a rut with it I need someone just to slap me in the face and show me what I'm doing wrong. :hehe:

BIDS error when opening SSIS package

Posted: 08 May 2013 01:22 AM PDT

Hi,When I try to open SSIS solution (created in BIDS on server having SSIS installed) on my local machine (do not have SSIS installed locally), I am getting below error:"Microsoft Visual Studio is unable to load this document.To design Integration Services packages in Business Intelligence Development Studio, Integration Services has to be installed by one of these editions of SQL Server 2008 R2: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration Services."As SSIS is not shipped with SQL Server Express, do I need to have a license version of SQL Server or is there any fix for it?Thanks,Puja

Restore of ReportServer and ReportServertempdb

Posted: 07 May 2013 04:59 PM PDT

I have to convert a named instance to default instance before that i have taken backups of all databases including reportserver and reportservertempdb. i have uninstalled the named instance and restored all the user databases after creating the default instance. But user responded the reports are not working. Do i need to restore the ReportServer and ReportServertempdb as well ? Is there any specific process to follow for restoring ReportServer and ReportServertempdb databases or same as like user databases ? Thank you for looking into my post. Appreciate all your help regarding this query !

How to configure sql alert to mobile SMS

Posted: 07 May 2013 02:39 PM PDT

We need to configure sql alert (SMS- short messaging service) (Log file full, and database down etc) to our on-call mobile (Airtel - india ,chennai) , i tried more concept but no luck. So please anyone help on this.. We have sql server 2005 and 2008 R2 version .....ThanksJerry

Regard to SQL Version,

Posted: 02 Dec 2012 11:27 PM PST

I have to SQL Server and one has version, Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) and the other server has version,Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) I just need to update the Microsoft SQL Server 2008 R2 (RTM) to SQL Server 2008 R2 (SP2),Need Assistance Please,Thanks,Bubby
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog