If you are using a full version sql server use the sql server agent to schedule the backup.

If you are using sql express you will nt be able to use...

I would force start sql server and try re-running the alter database statements with the correct path and filename I don't see why it wouldn't work.

hth

David

Well in the script you posted you did not specify the actual filenames just the logical filenames and the directories in which they would reside force sql server to start...

Sorry i may be being silly but is that exactly the code you used?

Shouldn't it be e.g depending on the filenames of the files moved in the case of msdb...

The service account under which sql server is running just doesn't have enough writes on the directories to which you moved the files.

If you just give the service account full...

Cannot find SSPI context is probably related to the SPN(service principal name) for the SQL Server not being set correctly.

You can check this using adsiedit but intsead of explaining it...

There's a few ways but if you want to capture the lock escalation etc on a particular table then you could use sql profiler.

I would not use ths to...

You can detach msdb by using trace flag 3608 but obvioulsy this means shutting down your server and restarting it with this trace flag.

If you can't recover msdb you can...

Marek Powichrowski (11/7/2007)

No, "with recovery".

So I must restore full backup with "no recovery" and next diff with "with...

Have you restored the last full backup first with norecovery?

hth

David

You could do this using xp_cmdshell this is disabled by deafult on SQL Server 2005 on new installs so you would need to turn it on before you could use...

There is another open source web admin tool for sql server which looks just like the good old enterprise manager. I just gave a link to a blog since its...

If you need to reduce the size of the log after rebuilding the indexes then I would use dbcc shrinkfile and put this as the final step in your job...

I would personally turn off auto shrink as its only real use is on development machines where space is at a premium. You can find numerous articles on why its bad...

Licensing in 2005 is done on a trust basis so it will use all 4 processors but you will obvioulsy be in violation of the license. Remember though that MS...