error with rebuild_log

i tried
dbcc rebuild_log('fake','\\databasename\F\Mssql\MSSQL\Data\fake_log.ldf')
and i got this error

Msg 5110, Level 16, State 2, Line 1
File '\\databasename\F\Mssql\MSSQL\Data\fake_log.ldf' is on a network device not supported for database files.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
yanci1179Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
rboyd56Connect With a Mentor Commented:
You cannot use rebuild log to rebuild the log on a remote computer. You have to rebuild the log on a drive on the local machine.  You need to change this:

\\databasename\F\Mssql\MSSQL\Data\fake_log.ldf

to somethin like F:\Mssql\MSSQL\Data\fake_log.ldf'

Remote drives are not supported with SQL Server unless you have trace flag 1807 enabled per article:

http://support.microsoft.com/kb/304261

This is highly not recommended by Microsoft.
0
All Courses

From novice to tech pro — start learning today.