Does the restore job is in hanged state for long time and eventually you are starting from scratch by restoring the full backup ? Can you check the restore job...

Check the copy job history I think that copy job might have failed and hence and there is no transaction log present in the secondary server.

Restore database pbfamily from disk='Path\filename.bak' WITH REPLACE

the above command will overwrite the pbfamily database.

(a) RESTORE FILELISTONLY FROM DISK = 'c:\xyz.bak' :- This command will give u the logical...

Scott,

Have a look at this link, http://msdn.microsoft.com/en-us/library/ms175191.aspx?PHPSESSID=6c7e47uec18v8n3121a6p001h4

which describes about the role of witness server which facilitates automatic failover. You can have Sql Express or Workgroup as a witness server. But...

I think your uninstallation was incomplete and hence the error. You can make use of the below link and manually uninstall Sql Server 2005,

http://support.microsoft.com/kb/909967

If that does'nt work make use of...

You cannot install Sql Server 2005 enterprise edition in Vista or XP you need to have a server OS like Windows 2003 to perform the same.

Also you cannot install Sql...

You can make use of SQL Server Migration Assistant for Access to perform the migration. I have not used this tool but it may be helpful.

Refer these links for...

As kk mentioned, the maximum size of the log file is 2 TB. Refer the comments from BOL

UNLIMITED

Specifies that the file grows until the disk is full. In SQL...

As Stephen mentioned, you can install Sql Server Integration Services by running the setup once again (from add/remove programs) and choose integration services to install it.

After it is installed...

Hello Binu,

A full backup will not truncate the log instead you need to take a transaction log backup which will truncate the log.

I agree you cannot restore a Sql 2005 backup to Sql 2000 server but you have an alternative in Sql 2005. You can make use of Database Publishing Wizard to...

[font="Tahoma"]In addition to the above responses you may wish to refer this KB as well,

http://support.microsoft.com/kb/317375

http://support.microsoft.com/kb/873235[/font]

[font="Verdana"]You need to remove the old entries of the server name, database name from the log shipping system tables. You need to remove the jobs manually and then remove the...

Welcome to the world of Sql Server 2005 🙂

You can practice using SSMS and create the databases. Refer the below link for MSDN Virtual labs which is a good place...

As indicated try to shrink the log file using dbcc shrinkfile. If the log file is not getting shrinked check if there any open transactions in your database using DBCC...