Viewing 15 posts - 11,236 through 11,250 (of 49,563 total)
Just restore over the existing database.
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...
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...
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.
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...
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...
October 22, 2013 at 1:17 am
Yes, the backup is striped over all the specified files.
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...
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...
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...
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...
October 22, 2013 at 12:50 am
In general, ignore it. It was part of Microsoft's (failed) attempt to simplify the fragmentation information
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...
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...
October 21, 2013 at 4:14 pm
Viewing 15 posts - 11,236 through 11,250 (of 49,563 total)