Forum Replies Created
Viewing 15 posts - 5,131 through 5,145 (of 19,564 total)
-
RE: findout Database Corruption
Here is an article about alerts you can configure about corruption.
http://www.sqlsoldier.com/wp/sqlserver/day10of31daysofdisasterrecoverymonitoringforcorruptionerror
Do you have checkdb jobs configured to run on a regular basis?
-
RE: How to manage log space issue, when you have more than 1 log file for a particular database?
There is possibly an impact on logshipping. If the primary and secondary are configured the same for files and file paths, the change will likely propagate to the secondary...
-
RE: MSSQLSYTEMRESOURCE NOT IN DATA DIRECTORY LIST
noel yu-371000 (1/20/2013)
If following those steps verbatim doesn't work, try this (http://www.sqlnotes.info/2012/01/06/new-way-to-relocate-resource-database/)I tried executing the SQL script "select name, filename from sys.sysaltfiles where dbid = 32767" -- No...
-
RE: MSSQLSYTEMRESOURCE NOT IN DATA DIRECTORY LIST
If following those steps verbatim doesn't work, try this
http://www.sqlnotes.info/2012/01/06/new-way-to-relocate-resource-database/
-
RE: MSSQLSYTEMRESOURCE NOT IN DATA DIRECTORY LIST
Did you start the server as the instructions say in step 7?
Start the instance of SQL Server in master-only recovery mode
-
RE: Need a backup script to get backup history status for the latest backup from all linked sql servers
sestell1 (1/19/2013)
I imagine everyone has their own approach to this.Your approach of using linked servers will definitely work.
I use a C# application I wrote that lets me run...
-
RE: EOMONTH - 1
Thanks Ron
-
RE: How to manage log space issue, when you have more than 1 log file for a particular database?
Somebody probably created the second file as a spillover due to the space issues.
If the drive where the first log file was created is out of space, I would migrate...
-
RE: Are the posted questions getting worse?
Lowell (1/18/2013)
Brandie Tarvin (1/18/2013)
All we need is an actual Go Faster flag for the database, and everything will be FINE.got your fix right here:
I need one of those
-
RE: Today's Random Word!
Ken Leeeeeeeeeeeeee
-
RE: Number of Rows
Hugo Kornelis (1/18/2013)
paul s-306273 (1/18/2013)
In my naivete I'm thinking 'so what?'.Is there a relevance to this?
That's what I though as well when answering the question.
I'm thinking the only value is...
-
RE: Are the posted questions getting worse?
Brandie Tarvin (1/18/2013)
Evil Kraig F (1/17/2013)
Was ill for a week, miss anything of import?The world came to an end, but the Doctor showed up and saved us all.
Didn't you see...
-
RE: Vendor DB backup job help.
davidwarner (1/17/2013)
Problem is that the files will just build up if the filenames are different. This current setup allows the files to just roll over the next day.And what if...
-
RE: CASE statement not working properly
Lisa Liel (1/17/2013)
Forgive me for wasting your time. Someone had started adding code into my proc with an IF statement, and hadn't closed it or commented it out. ... -
RE: CASE statement not working properly
3 votes for the actual query.
Viewing 15 posts - 5,131 through 5,145 (of 19,564 total)