the statment u ran 'with rollback imme...' would disconnect all users except you as u're also connected by the query window u typed that statement. Once u close that query...

are you sure you typed the name of the backup file correctly?

Also, did you take the db backup directly on tape or did you backup ur db on disk and...

auxinet07 (6/13/2009)

---

Thanks Pradeep - can I come back to you for further assistance if I came across problems - I will try out the steps you have outlined on Monday.

Unfort....

Even in simple recovery mode, all your transactions are written to the log file. The only difference here is that the log is cleared everytime SQL Server fires a...

and you can remove all your connections(except yours) by this:

alter database yourdb

set single_user with rollback immediate

Just remember, this will force user connections to drop. all running queries will be rolled...

Fortunately or unfortunately, you'll find these regular posters on all SQL forums!!:alien:

This is not just any other forum. I've learnt SQL administration here and got a new job. Thanks to Gail, Jeff and many of you who constantly give best advices...

There are in all 4 system databases in sql 2000 (Master, model, msdb and tempdb)

as far as system databases are concerned, you cant backup tempdb, so just leave it.

As far...

you can query MSsubscription_properties table on the subscriber (pull subscriptions) and at distribution db for push subscribtions.

refer

http://msdn.microsoft.com/en-us/library/ms190291(SQL.90).aspx

you can. however, since the structure of person.address is different from what was shown in the example, you'll need to modify the queries for inserting.

You can also create a permanent...

suppose one of your user's database's name is db1

Open SQL Server Enterprise Manager on the source server. Click on Tools->SQL Query Analyzer.

Copy the statement mentioned below for and run it....

Thanks for the feedback 🙂

1. your updated post came after my reply.

Anyways,

I use the built in backup facilities within SQL Server 2000 to create a backup of the databases...

you posted the problem in an incorrect forum(2005).

also, from the title of the thread, it seems you want to restore the database to a prior state. in such case...

If you are restoring a database from a backup file,...

Try taking the backup to a new file, instead of backing in the same file.

you may find these links useful:

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

http://www.sqlservercentral.com/Forums/Topic597271-357-1.aspx