California (9/3/2008)

---

well guess what? It worked. all what i did was:

select * from dbo.[DB.Documents] -- Yes changed the DB.D to Upper case --- thats how the table is defined and...

Yup. It only takes a couple of clicks in the GUI, and...

We put our log files on the E drive which is physically on the server, and our data files go on the SAN. Keeps them nice and separate.

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...