July 27, 2011 at 8:17 am
I have a Virtual VM SQL Cluster which went down
I can browse to the MDF/LDF file but cannot open Microsoft Studio.
How can i start a new server
Windows 2008 /SQL 2008
Or should i have to do this via Power script ?
July 27, 2011 at 8:30 am
I suspect that you're a bit confused. Let's see all your points one at a time:
I can browse to the MDF/LDF file
Fine. However, there's no need for this.
but cannot open Microsoft Studio.
I guess you mean SQL Server Management Studio. It doesn't start? Do you get any errors?
How can i start a new server
I suppose you mean "start the service". Go to services, navigate to SQL Server service and click start.
You can do this from the start menu: Microsoft SQL Server, Configuration Tools, SQL Server configuration manager.
Or should i have to do this via Power script ?
You mean Powershell Script? There's no need for that.
Don't take offence, I say it with the only intent to help you: call somebody who knows what to do.
Hope this helps
Gianluca
-- Gianluca Sartori
July 27, 2011 at 8:50 am
Maybe speak to the DBA there?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 27, 2011 at 9:26 am
Or in the worst case, restore a backup of the VM itself (maybe a prior snapshot). You may need to chat with your server administrators for that though.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 27, 2011 at 3:26 pm
SQLRNNR (7/27/2011)
Or in the worst case, restore a backup of the VM itself (maybe a prior snapshot). You may need to chat with your server administrators for that though.
But wouldn't you give up any technical support from MS if there'll be an issue with SQL Server when restored from a VM snapshot?
As per MS support policy
Virtualization Snapshots for Hyper-V or for any virtualization vendor are not supported to use with SQL Server in a virtual machine. It is possible that you may not encounter any problems when using snapshots and SQL Server, but Microsoft will not provide technical support to SQL Server customers for a virtual machine that was restored from a snapshot.
July 27, 2011 at 4:33 pm
i had a cluster that failed and i dont see any infor except for mdf/ldf file
when i click on Microsoft studio i get
when i click start-programs-MS sql server 2008-sql server management studio--i get this message..
'The item Ssms.exe that this shortcut refers to has been changed or moved,so this shortcut will no longer work properly'.
BUt i can see bot mdf/ldf file the only option is to copy the file
and put it on new server
OR can i just reinstall the files would i loose the settings and will my database come up ?
Its production server
July 27, 2011 at 4:58 pm
Do you have SQL Server Services in services.msc?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 27, 2011 at 5:04 pm
NO i dont have any ms sql service running
should i just reinstall SQL server and would i get back my MDF and ldf files ?
July 27, 2011 at 5:05 pm
clearification
I dont see any MSSQL services in my services
July 27, 2011 at 5:10 pm
Sounds like SQL Server was uninstalled or this VM was restored to a point prior to SQL having been installed.
You need to reinstall SQL Server and then reattach your database files.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 27, 2011 at 6:34 pm
Seriously, call a pro. Ideally the one who has setup your systems.
You're not the man to complete that task.
July 27, 2011 at 7:01 pm
Your error is telling you it can't find SSMS. And if you don't have any MSSQLSERVER services then it seems as though all reminents of SQL Server are no longer on that VM. But if the VM was restored to a time previous to the instance install, then the database data and log files (mdf and ldf) wouldn't be there.
July 27, 2011 at 7:28 pm
i can also move the file to another server and attach mdf/Ldf without loosing data ?
July 27, 2011 at 7:39 pm
Yes, you can just attach the database files to another server. So you aren't concerned with the existing server's lack of SQL Server footprint? Not sure what you're visible solution is (concern for instance AND database or just database?).
July 27, 2011 at 7:42 pm
http://msdn.microsoft.com/en-us/library/ms190794.aspx
Please reference the above link if you are just concerned with transporting the database through attaching.
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply