Viewing 4 posts - 1 through 4 (of 4 total)
disregard previous post - use quotes worked.
THANK YOU.
September 25, 2012 at 11:03 am
tried:
USE SAML;
GO
DBCC ShrinkFile("SPGSAMLLog.ldf", 3000)
returned:
Msg 8985, Level 16, State 1, Line 1
Could not locate file 'SPGSAMLLog.ldf' for database 'SAML' in sys.database_files. The file either does not exist, or was dropped.
UGH
September 25, 2012 at 11:00 am
ran this: SELECT name FROM sys.master_files WHERE database_id = db_id() AND type = 1
it returned: SPGSAMLLog.ldf
tried:
USE SAML;
GO
DBCC ShrinkFile(SPGSAMLLog.ldf, 3000)
it returned:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '.'.
September 25, 2012 at 9:20 am
Thanks for responding. I'm back on this...
I ran: SELECT [name] AS logical_file FROM sys.database_files df
It returned:
logical_file
SPGSAMLDat.mdf
SPGSAMLLog.ldf
USE SAML;
GO
DBCC ShrinkFile(SPGSAMLLog_log, 3000)
Msg 8985, Level 16, State 1, Line 1
Could not locate file 'SPGSAMLLog_log'...
September 24, 2012 at 1:01 pm
Viewing 4 posts - 1 through 4 (of 4 total)