#@$ @#$224rd Official Hard At Work Thread#@$@$#
Joined: Aug 2002
Posts: 53,292
Likes: 789
From: Owings Mills, MD
Originally Posted by speed_bump,Aug 11 2009, 04:53 PM
SQL 2000 bleh, email to team so maybe someone who works here learns somethingFirst, I had to take ownership of the database:
EXEC dbo.sp_changedbowner @loginame = N'sa', @map = false
Detach the database
Attach the database (this got rid of the file not found errors)
This allowed me to take a backup of the transaction log via the GUI, which was full because the recover mode was set to FULL instead of Simple
Then I tried to shrink the log file size to 1 GB
DBCC Shrinkfile(MF20_log,1024)
The file size didn't change, so I had to backup via SQL. This actually just truncates the logs, doesn't create a backup file.
BACKUP LOG CitrixMFXP WITH TRUNCATE_ONLY
When I ran the SQL to shrink the log again, it was successful.
DBCC Shrinkfile(MF20_log,1024)
Registered User
Joined: Mar 2002
Posts: 24,687
Likes: 195
From: MoCo
Originally Posted by TepEvan,Aug 11 2009, 05:03 PM
SQL 2000 bleh, email to team so maybe someone who works here learns somethingFirst, I had to take ownership of the database:
EXEC dbo.sp_changedbowner @loginame = N'sa', @map = false
Detach the database
Attach the database (this got rid of the file not found errors)
This allowed me to take a backup of the transaction log via the GUI, which was full because the recover mode was set to FULL instead of Simple
Then I tried to shrink the log file size to 1 GB
DBCC Shrinkfile(MF20_log,1024)
The file size didn't change, so I had to backup via SQL. This actually just truncates the logs, doesn't create a backup file.
BACKUP LOG CitrixMFXP WITH TRUNCATE_ONLY
When I ran the SQL to shrink the log again, it was successful.
DBCC Shrinkfile(MF20_log,1024)
