The backup command does not require the filename so not sure why you need it. How are you doing your backups?

IF you want to get filenames extract them out of...

varunlpu,

to move master you only need to amend the startup parameters, stop SQL, copy files to new location, and restart SQL.

(and then cross fingers) 🙂

did you drop the database via the gui? If so did you untick the delete database history radio button, not doing so can cause the drop database to take a...

defiantclass (4/27/2013)

---

Ok, so when I drill down in Windows Explorer to the physical file, the size of it there is not reflecting the amount of data in it (meaning it...

long shot (I hope) and I doubt it but they didn't rename the server did they?

maint plans should produce a .txt file in the install path\log directory, any errors in...

If you have explicitly amended the size of a tempdb database file via an alter database command that is the size it will recreated at on restart.

Any data in tempdb...

has the SQLAgent service been restarted. Some sysadmins do not realise that restarting the SQL service does not restart the agent.

thanks for clarifying, I thought thats what you meant. And that allows you to install RS as part of the default instance on the second node instead of in its...

I cannot think of any good reason to change system database file names and cannot guarantee it won't cause a problem either now or with some future change MS makes...

I have also never had to try this either so I would have to agree with Perry that thats the only safe, guaranteed way to do it.

also the fact that...

could you expand on that perry?

Steve JP (4/27/2013)

---

Without breaking anything?? I very much...

removed -may be incorrect

if you don't need point in time recovery set your recovery mode to simple, else schedule regular transaction log backups, that will prevent the log growth.

There is NO need to...

A million? that should keep me going for a while. Glad that's sorted 🙂