You can either create a Network Drive (mapped drive of some other machine on your machine) or a UNC path to that machine.

For example :

\\machinename\sharename

OR

Driveofnetworkmachine(F:\)\foldername

You need to make sure...

Thanks for the information.

From what I understand now is that I can restore a database on one server of one collation to another server of different collation. Here the restored...

Hi, Will this not do ?

use master

select * from sysaltfiles

--Kishore

This is the syntax for creating a dumpdevice over a network.

EXEC sp_addumpdevice 'disk', 'networkdevice',

   '\\servername\sharename\path\filename.ext'

Refer sp_addumpdevice  in BOL for more info.

--Kishore

Hi,

From what I understand is that you are trying to append to a existing backup file.

Looks like the existing backup file is corrupted.

Tried trying create a new backup file OR Try...

hi Prasad,

How can you do it ? (your first answer)

Lets take a example:

I have a database filegrpdb1 with these 8 data and 1 log file.

C:\Program Files\Microsoft SQL Server\MSSQL$SQL2KA\data\\filegrpdb1_fgrppf1_dat.mdf

C:\Program Files\Microsoft SQL...

Hi Rajendra,

At the first place, you should not play with your production database, and you should always take a backup before doing any kind of implementation like replication etc.

Anyways, what...

You can even check by right click on properties of that particular instance under Enterprise Manager. It should be showing :

Product Version : 8.00.2039(SP4)

--Kishore

I have been running my sql server for 4 years now. Only needed to reboot when there are security updates, or initially we had battery problems, but then tht was...

If you are using a sql server 64-bit veriosn, adding extra memory does not call to add the /3gb /pae swith to the boot.ini file. It recognizes the additional memory...

There may be a case where your transaction log backups itself are not working. If the job fails for some reason, it will not delete your old backups.

--Kishore

If you are .ldf file is in place, you can take a T-log backup with No_Truncate.

However, if you are not able to take a log backup, you will be able...

SQL Server Registering - unregistering should not make any differences to the databases under that instance.

You may want to do a dummy check :

Register one sql server instance.

Create a...

Why dont you directly take the backups on the network path ? Why do you want to take a backup first and then copy to a remote drive.

Steps:

1. Map the...

Thanks for ur answers. The best part is that I need not do anything if i am using a 64-bit sql server on a 64bit machine. It will take care...