Viewing 15 posts - 11,236 through 11,250 (of 49,552 total)
DBCC loginfo
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
October 22, 2013 at 7:31 am
Just restore over 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
October 22, 2013 at 1:56 am
hoseam (10/22/2013)
Directory lookup for the file "C:\Databases\SQLDevTest.mdf" failed with the operating system error 2(error not found).
Msg...
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
October 22, 2013 at 1:53 am
Database files in the root of C? Sure that's a good idea?
As for the ALTER DATABASE, the syntax you listed is correct. Make sure you haven't highlighted part of 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
October 22, 2013 at 1:41 am
Profiler it should do, otherwise catch the error in the application. Don't run profiler against a busy production server.
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
October 22, 2013 at 1:33 am
Does the directory exist? If not, then you will get an error.
These errors are ones you (being the DBA who knows the layout of the server and the drives) needs...
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
October 22, 2013 at 1:30 am
The error tells you exactly what's wrong. You're specifying a non-shared drive for database files for a clustered SQL Server.
"Cannot use file 'C:\Databases\SQLDevTest.mdf' for clustered server. Only formatted files on...
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
October 22, 2013 at 1:17 am
Yes, the backup is striped over all the specified files.
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
October 22, 2013 at 1:05 am
Which files does the script reference that you expect to be sent?
This is just a create database for a SQL Server 2012 database scripted from management studio. Yes, most of...
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
October 22, 2013 at 1:02 am
djordan 4543 (10/21/2013)
I am beginning to doubt that sql dbengine does not timeout anymore - is there any option you can use to make a query timeout?
No. The only query...
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
October 22, 2013 at 12:59 am
SQL Server has no concept of query timeouts for queries it's running. Timeout is a client application setting. The client application decides it's waited too long and tells SQL server...
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
October 22, 2013 at 12:54 am
You're writing two backups to the same file. You didn't specify to overwrite, so SQL appends. Hence that file now has two backups and is the size of the two...
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
October 22, 2013 at 12:50 am
In general, ignore it. It was part of Microsoft's (failed) attempt to simplify the fragmentation information
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
October 22, 2013 at 12:48 am
DBCC CheckDB (<database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
I'd still remove the nolocks, they definitely can cause you problems, by design they can result in incorrect data. As I said, not usually...
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
October 22, 2013 at 12:33 am
PradeepVallabh (10/21/2013)
The way i understand, it's almost similar to Timestamp
It is timestamp (renamed). It'll be there unless you're working with SQL 2000.
It's not a datetime, it's nothing to do...
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
October 21, 2013 at 4:14 pm
Viewing 15 posts - 11,236 through 11,250 (of 49,552 total)