Viewing 15 posts - 32,671 through 32,685 (of 49,552 total)
No time limit that I know of.
When I wrote my 2008 exams, I wrote one of the ITPs as a beta, then came back almost a year later and did...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2010 at 6:01 am
Now for an emergency mode repair.
DBCC CheckDB('InProSys', REPAIR_ALLOW_DATA_LOSS)
Post any output.
I assume, since it's a test database, if it's not recoverable there's no big problem?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2010 at 4:47 am
Please don't crosspost. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic930303-150-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2010 at 3:49 am
smratisharma (5/31/2010)
You can Use the following Query to Shrink the Log File.USE DatabaseName
GO
DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 1)
GO
For More Info Please Read : http://blog.sqlauthority.com/2006/12/30/sql-server-shrinking-truncate-log-file-log-full/
That is appalling...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2010 at 3:40 am
jpage01 (5/31/2010)
So, am I totally without options here?
Pretty much, yes. This is not repairable.
After setting the DB to emergency mode (but before trying the repair), can you access the DB?...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2010 at 3:27 am
Do your initial restore WITH REPLACE. That tells SQL that you're happy to overwrite the existing database.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2010 at 3:26 am
smratisharma (5/31/2010)
EXEC sp_resetstatus ‘yourDBname’;
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb(‘yourDBname’)
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2010 at 3:23 am
SQL 2008 Express is limited to 4 GB per database. I belive SQL 2008 R2 express has a higher limit, but it's still limited. You can create multiple databases, but...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2010 at 1:53 am
Then you will need to rebuild MSDB. You will lose all of your jobs, all of your backup history. I hope you have the jobs scripted somewhere.
I have no clue...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2010 at 1:47 am
Why the hell don't you have a backup?
Try setting the DB to emergency mode. If that gives any errors, post them here. Don't try anything else for the moment.
ALTER DATABASE...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2010 at 1:43 am
dronov (5/31/2010)
Otherwise<c/> restore from backup if the problem results in a failure during startup.
I think the error's pretty clear what you need to do. Restore from your last good...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2010 at 1:29 am
Quatrei.X (5/31/2010)
but still, does anyone know any workaround to this
Buy a license for a higher edition of SQL Server and upgrade. Express is free, hence it's reasonable that it's limited.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2010 at 1:28 am
No, not at all.
I mean you need to restore from the database backups that you have taken of MSDB. As in RESTORE DATABASE msdb FROM ...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2010 at 1:26 am
Restore MSDB from last good backup.
You do have backups of MSDB, don't you?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 30, 2010 at 11:41 pm
Atif Sheikh (5/30/2010)
Yes, Truncate is depricated in SQL Server 2008 as said by Steve. You can check tons of articles and blogs on this on the internet.
Truncate only was deprecated...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 30, 2010 at 11:15 pm
Viewing 15 posts - 32,671 through 32,685 (of 49,552 total)