Its 2005 enterprise edition. I need to find out what's causing...

psemenye (7/21/2009)

---

Hi guys,

I need some help in understanding SQL transaction logs. I want to find out whether certain information was put into a database using insert or update statements (basically...

pete (7/21/2009)

---

Thanks but I am still having issues. I have a back up of MSDB from the other sql installation which contains the job info. So I try...

The information you've provided is so trimmed that it's hard to provide some...

declare @BackupDest varchar(100)

set @BackupDest = 'C:\MyDB\MyDB_' + convert(varchar,getdate(),112)+'.BAK'

BACKUP DATABASE MyDB

TO DISK = @BackupDest WITH INIT

A trimmed version of the same code 😉

There can be numerous reasons for a maintainance plan to fail depending on the type of plan you have. If you provide...

Cant think of anything as of now as nothing is in the error log.. Can you post the entire T-SQL code of the maintainence plan so that others can have...

Look out for DBCC SHRINKDATABASE OR DBCC SHRINKFILE in BOL.

In most of the cases, restart is the only option.....

Can you see the backup file even after the job fails? If yes, can u verify if it's correct? If no, can u check disk space? May be its failing...

We dont take entire disk's image. Instead, we backup all system databases including resource database and user databases. If we need to revert back, we'll use these backups to revert...

Thanks Gail 🙂

vetri (7/20/2009)

---

Hi all,

I changed the Default port number of SQL SERVER to some specific port number now i am able to connect the server using ,,Also only the is...

You can take database backup from anywhere(client...

By running BACKUP DATABASE

i'd suggest you read BOL on how...

EDIT - Double Post.