No, you can't see the network drive. But you can copy-paste the network path into the file location area.

To avoid network problems interfering with the backup, you could backup locally,...

Idera's Compliance Manager can tell you when changes were applied. I can't remember if it captures the actual SP code, or just logs that ALTER PROCEDURE occured by Person_A on...

I found this on another forum:

Disclaimer: I have not done this... I am just copying what was posted elsewhere in the hope that it helps. Can you set up a...

I used different Idera products at my previous job (Diagnostic Manager, SQLSafe, Compliance Manager). They were pretty good. As suggested, get...

sahoong (8/29/2008)

---

Hi Gurus,

I have just taken over the administration of a database. The backup procedure is

1. Shutdown SQL server

2. Copy the SQL files to "D:\Backup\yyyy mm dd"

3. Start SQL...

It amazes me that the lack of backups is so common. I will be starting a new job soon, and after finding my desk, the first think I will do...

You can run something like this to identify databases that have not been backed up in the last n days:

select * from master..sysdatabases db

where (not exists

(select * from msdb.dbo.backupset

where...

tempdb is the only db you don't need to backup. It's always better to back up too much & too often (within reason of course) ....... but "Murphy" is always...

Who made the decision not to have daily backups ? Can't just blame that on your co-worker too, can you ?

Do I understand correctly that Table_A has the additional columns, and that you want to add Table_B as a newly replicated table ?

I've done the following when making changes to...

Christopher Favero (8/26/2008)

---

Oberion (8/20/2008)

---

if repl is already setup, u can add a new table if you like via the gui or syntax. Since you are asking, you should do...

I remember doing it on SQL 2000 also. I couldn't browse to the file location in the backup & restore GUIs, but I could "copy-paste" it into the file...

I haven't been on 2000 in a little while, but I think you can script out all the objects from your production database to a single .SQL file. Then create...

Rather ironic that the OnlineExam database didn't get backed up.

Going forward, you can run something like this to identify databases that have not been backed up recently:

select * from master..sysdatabases...

jchen (8/25/2008)

---

I will migrate db to a new envirentment by sql server 2k5. I need to estimate what hardware and sofware which I need for migration. Here is my configuration...