messenjahofchrist (8/4/2009)

---

I want to set up one to many replication. If the table does not exist at the subscriber for the first synchronization does sql create it automatically? If not...

quoting from BOL

This means fragmentation will be higher after...

Gianluca has a valid question.

You may want to search for Backup Log with Truncate_only/DBCC SHRINKFILE in BOL. But you should understand the consequences first.

Can u explain...

arun (7/29/2009)

---

I need to take backup from remote server database to my local machine. I searched on google and could not found out. Please let me know how do I...

The link provided by Gail explains clearly on why count(*) would be faster than count(column). Thanks for writing that article!!

Thanks for the correction 🙂

drew.allen (7/29/2009)

---

I recommend that you TEST your solutions before posting, even for something apparently this simple. It helps no...

murthykalyani (7/29/2009)

---

There is no such table by the name backupfile in msdb database.

Ram[/QUOTE]

The table is present.

Please query by joining these tables backupset and backupmediafamily and you can get...

query the backupfile table in msdb database and see physical_name column if it gives the backup destination(not sure)... i cant test it right now coz of some issues....

Open the maintainence plan and click on view T-SQL to see where it's storing the backup files..

sarvesh singh (7/29/2009)

---

The reason i want to delay this is because the some of the fields gets updated after the audit process which is done in Java. My Java knowledge...

Thanks Gail. 🙂

Definately i need to google more on this topic 😉

i'm not sure whether waitfor is not allowed in a trigger. if it's so, you can call a dummy proc from the trigger. the proc would contain the code for...

16 TB for data file and 2 TB for log file, 524,258 TB for the database. There...