bigsloth
Member | Редактировать | Профиль | Сообщение | ICQ | Цитировать | Сообщить модератору
MNT
в BOL пишут так:
Цитата: When you start an instance of SQL Server in single-user mode, SQL Server Management Studio can connect to SQL Server. Object Explorer in Management Studio might fail because it requires more than one connection for some operations. To manage SQL Server in single-user mode, execute Transact-SQL statements by connecting only through the Query Editor in Management Studio, or use the sqlcmd utility.
When you use the -m option with sqlcmd or Management Studio, you can limit the connections to a specified client application. For example, -m"sqlcmd" limits connections to a single connection and that connection must identify itself as the sqlcmd client program. Use this option when you are starting SQL Server in single-user mode and an unknown client application is taking the only available connection. To connect through the Query Editor in Management Studio, use -m"Microsoft SQL Server Management Studio - Query". |
http://msdn.microsoft.com/en-us/library/ms188236.aspx
Т.е., надо запустить SSMS, Object Explorer скорее всего отвалится - это нормально, надо будет нажать "New Query" и ввести пользователя\пароль. После того, как подключитесь, надо будет выполнить:
Код: use master
alter database tempdb
modify file(
name = tempdev,
filename = N'C:\Новое_место\tempdb.mdf')
go
alter database tempdb
modify file(
name = templog,
filename = N'C:\Новое_место\templog.ldf')
go |
|
