Did you reboot the server as well? You need to for the PAE switch. You should check Microsoft's site on when to use /PAE, /3GB, etc.
Get a good backup. Copy the backup file (BAK) to the new server. Create the database on the new server. Restore the backup, and change the paths...
The log is in use whenever the database is up. You probably have to disconnect the database to copy the LDF file.
By any chance is this an external drive? If so, there should be a light to indicate a problem. Perhaps a red light, an X, or maybe a...
We do log shipping on 4 databases. I have found that 4 different log shipping procedures work better. That way, if I need to stop logshipping on 1...
On second thought, try this first without pointing to master. Its Friday and it is late in he day, so my brain is mush....
I was wrong in the database to point to. You have to point to master.
Try this: 1. Point to the database that you want to assign the user to 2. sp_change_users_login update_one,'moon','moon'
Is it possible that the database is staying onliine but their connections are getting dropped? How do they connect?
I think you will have to do a tran log backup after 16:21 but before 16:29. That way, the record count will be 39000. Then you could restore until...
It looks like you will have to restore another TranLog backup before you get your records. The last tran log backup was before you had 39000 records...
There is also a procedure called sp_help_revlogin<br /><br />Part 1:<br />REATE PROCEDURE sp_help_revlogin @login_name sysname = NULL AS<br />DECLARE...
sp_cycle_errorlog This will recycle the errorlog
I have not tested the SP with SQL 7.0. Also, this SP creates the users. I am not sure if it actually will make the assignment to the proper...
Once you have both SPs put into the master database on both servers. You run sp_help_revlogin on the source server. You then can run the output of...
I used sp_help_revlogin. My boss found this a few months back.<br /><br />CREATE PROCEDURE sp_help_revlogin @login_name sysname = NULL AS<br...
What is the RTM version? Is it free? How do I get it?
I just downloaded and installed the SQL Server 2005 Management Studio Express CTP. I have no problem connecting to any SQL 2000 servers in my...
I had this same problem. It turns out that the backups weren't exactly spaced 1 day apart (a few seconds or a few minutes). I changed the "delete...
It is bulk logged. The database is from a vendot
Separate names with a comma.
