you need to give the fully qualified domian name as follows,

refer this link, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1854090&SiteID=1

refer, http://msdn2.microsoft.com/en-us/library/aa197922(SQL.80).aspx 

for performing edition upgrade in sql 2000

hi, you want users to use both ur headoffice and factorys prod servers i.e update simultaneously in any 1 of those depending on the availability....and later jus want to...

hi, you want users to use both ur headoffice and factorys prod servers i.e update simultaneously in any 1 of those depending on the availability....and later jus want to sync...

moreover you can even restore master from cmd by using sqlcmd utility...but for that too you shud start sql as i mentioned......after starting sql in single user mode, just type...

hi Jim,you cannot start from SSMS in single user mode

       You can start sql 2005 in single user mode by performing the below steps,

1.go to cmd and type net start mssqlserver...

Yes you can very well automate this process through log shipping........wat log shipping does is

The basic idea is nothing but backup and restore of the database and transaction...

just refer the link for moving sysdatabases.....

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

also i belive yours is default instance ......

1.firstly take a backup of all teh dbs in your present system....install sql server in another system......and subsequently restore all your dbs with the backup you took from old system........while...

hi refer ,

http://support.microsoft.com/kb/246133/ ---this is wat sugesh was mentioning

Hi Franc,

           After reboot what is the exact error ? ? ?  .....you cant open management studio or cant even access the dbs ? ? ? .....s you can copy the...

use master

go

alter database DBName

set recovery simple

or else you can also change the recovery model by

goto object explorer in Management studio---right-click the db---properties---opotions---recovery model........

hi,as every 1 rightly stated u truncate the log and then perform dbcc shrinkfile...also change the recovery model to simple .... coz it will truncate the log file in that...

hi u can verify the integrity of the backup using restore verifyonly command....

http://msdn2.microsoft.com/en-us/library/ms188902.aspx

hi tom,

        i a bit baffled by this.....since ur monitor says the last file restored as 14:40 and u only hav the latest @14:30 in C:\drive of secondary.....i feel that sum1 had accidentally deleted...