Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Unable to start SS2008R2 in minimal config mode

Author  Topic 

Analyzer
Posting Yak Master

115 Posts

Posted - 2012-05-01 : 09:28:32
Hi,

By accident trashed TempDB files when moving them so now need to start sql in minimal config mode to repair using ALTER DATABASE command. sqlservr.exe -f -s <instance_name> starts sql but fails on permissions and I don't know the SA pwd.

My other attempt is to modify the startup parameters by appending last character with ;-f but this is not working either.

Any idea on syntax, where to correctly place the -f in startup parameters or rebuild the TempDB?

Thanks in advance
   

- Advertisement -