Viewing 15 posts - 34,396 through 34,410 (of 49,552 total)
There's a space missing on the first of those parameters
-dF:\MSSQL\OVOPS\Datafiles\master.mdf
should be
-d F:\MSSQL\OVOPS\Datafiles\master.mdf
Fix that and see if that lets SQL start or at least changes the errors.
January 26, 2010 at 12:55 pm
Sopheap Suy (1/26/2010)
It is advised that you should not move master or mssqlsystemresource. It is possible to move it in 2005, but not 2008.
It's possible to move master, providing...
January 26, 2010 at 11:48 am
Ok, it's not model or msdb that you messed up, it's master.
Is the master data file in this directory? F:\MSSQL\OVOPS\Datafiles\master.mdf
Is the master log file in this directory? G:\MSSQL\OVOPS\Logfiles\mastlog.ldf
If not, move...
January 26, 2010 at 11:43 am
What does the SQL error log say? It's a textfile, will have the name ERRORLOG.
January 26, 2010 at 11:01 am
harpistic (1/26/2010)
January 26, 2010 at 10:58 am
harpistic (1/26/2010)
January 26, 2010 at 10:10 am
"I've never heard of that term. Here are some suggestions anyway"
http://www.sqlservercentral.com/Forums/FindPost853704.aspx
This time it's not the question that's bad....
January 26, 2010 at 9:33 am
To even begin to get you a working solution, I'd also need to see the definition of the source table and some sample data in it.
January 26, 2010 at 9:32 am
MothInTheMachine (1/26/2010)
Thanks Gila...I had never heard of that term 'suspect' so I was shooting in the dark.
Forgive me for being blunt, but why are you offering advice and suggestions...
January 26, 2010 at 9:26 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 26, 2010 at 8:13 am
MothInTheMachine (1/26/2010)
January 26, 2010 at 7:46 am
jvElecenter (1/26/2010)
Does this lead to performance issues ?
Not by itself, no.
January 26, 2010 at 7:44 am
A general network error is just a general can't connect error. Most likey cause is that the SQL Service is not running. You need to get remote access to the...
January 26, 2010 at 7:42 am
Are you sure that you want to do that? What happens if, when going to restore, you find that the latest full DB backup is corrupt? Or find out that...
January 26, 2010 at 7:40 am
Grant Fritchey (1/26/2010)
Only the unique constraint on the index would be of use when looking at the execution plan.
And whether or not it's filtered
January 26, 2010 at 7:30 am
Viewing 15 posts - 34,396 through 34,410 (of 49,552 total)