Ue sp_addumpdevice stored procedure to add a network dump device. Then simply refer this backup device in your BACKUP DATABASE command

run DBCC SQLPERF(LOGSPACE) command to view the total transaction log space and %used for every database.

ackup the transaction log. Backing up of the transaction log will automatically issue a checkpoint. Then you can use DBCC SHRINKFILE to actually reduce the size of the log file.

Suppose you are defragging index and suddenly you tried to stop/cancel the command, then how will the database be restored to its previous consistent state? The thing here is, evenif...

When SQL Server performs some operation, it loads as many related pages as it requires into the memory. For example, suppose you are running a stored proceudre which forces full...

First of all, please let me know if the database is in SIMPLE revovery mode or FULL or BULK-LOGGED. The truncation commands can remove valuable entries from the transaction log...

Hi,

First transfer all the logins from SQL Server 7.0 to SQL Server 2000 through DTS or scripting out the logins at SQL Server 7.0 and running the script at SQL...

packet errors while reading or writing packets for xeswww011.

 here xeswww011 is the name of the server

Please suggest.

Better create an application role, and configure that role with the permisions you want.

Pankaj

If you stop the stop the service when tranaction log is full, then depending upon the recovery interval configured for your server, there can be less or many tranactions that...

In a clustered environment, all the nodes should have the same path for binaries and executables installed on each of them. This happens at the time of installation. Also, please...

The Proxy account enables the non-sysadmins to run the command line utilities and run ActiveScripting job steps. To configure it, go to the properties of SQL Agent and then go to...

he greg gave the correct command. However, sp_helpdb <database-name> will also give you the information about the transaction log space (along with data file space).

Pankaj

go to the query analyzer and type sp_who command to see who are the users that are using the database. If the running transactions are not critical (meaning that if...

You can transfer all the jobs using DTS. Go to enterprise manager => select server => Data Transformation Service => local packages

Make new package here by selecting "Transfer Jobs"...