Viewing 15 posts - 40,021 through 40,035 (of 49,552 total)
I agree with Jack. That's not right. It's easy for people to get a poster's history if they want to.
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
April 2, 2009 at 9:02 am
sunny Brook (4/2/2009)
is it possible that the files you are trying to access are also part of some other good DBs?
The file in question ('D:\MSSQL.1\MSSQL\Data\Academic Reporting.mdf:MSSQL_DBCC9') is al alternate...
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
April 2, 2009 at 8:44 am
Double post. Sorry
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
April 2, 2009 at 8:39 am
Restore from scratch each time.
Write a custom sync program or a rather complex SSIS package to do the same thing. This will have a non-trivial impact on production
Replication's the usual...
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
April 2, 2009 at 8:33 am
Are you running this in a job? If so, check the SQL agent permissions.
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
April 2, 2009 at 8:23 am
Anukul (4/2/2009)
Can you provide a script to restore all differential backs hour after hour?
No need. It's trivial. Add WITH NORECOVERY to all of your restored. However that means that the...
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
April 2, 2009 at 8:13 am
Check the permissions on the directory D:\MSSQL.1\MSSQL\Data\ and make sure that the SQL service account has access. Note that it is possible to have a dir that administrator has no...
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
April 2, 2009 at 8:10 am
Bob Hovious (4/2/2009)
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
April 2, 2009 at 8:01 am
OS service packs and application service packs are completely unrelated and don't affect one another
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
April 2, 2009 at 8:01 am
Are you sure you read the link?
Part way down there's a link to a second article 'Considerations for restoring the master database'. In there there's a piece on starting...
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
April 2, 2009 at 7:52 am
Achtang (4/2/2009)
Yes, I can restore the master database if the server is running but What if the sql server does not start at all at the start up.
Did 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
April 2, 2009 at 7:33 am
To restore more backups the database has to be in norecovery, which means it's not readable. Diff backups aren't really suitable for keeping a test server up to date. Have...
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
April 2, 2009 at 7:32 am
Ramesh (4/2/2009)
Anyways, I still think that he deserves a little more help and that too if he shows his willingness to learn and try things on his own.
We've tried to...
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
April 2, 2009 at 7:29 am
Grant Fritchey (4/2/2009)
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
April 2, 2009 at 7:23 am
Corruption 90% of the time is a hardware issue.
http://www.sqlskills.com/BLOGS/PAUL/post/How-to-tell-if-the-IO-subsystem-is-causing-corruptions.aspx
http://www.sqlskills.com/BLOGS/PAUL/post/Search-Engine-QA-26-Myths-around-causing-corruption.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
April 2, 2009 at 7:19 am
Viewing 15 posts - 40,021 through 40,035 (of 49,552 total)