BACKUP DATABASE [Database_Name] TO

DISK = N'D:\Backup_folder\Database_Name_1.bak',

DISK = N'C:\Backup_folder\Database_Name_2.bak'

This will divide and save your backup.

Stored procedure

A stored procedure is a program (or procedure) which is physically stored within a database. The advantage of a stored procedure is that when it is run, in response...

In the backupmediaset[/size][/u][/i][/b] table, the is_compressed column tells you whether or not the backup is compressed.

Go to Start > Programs > Administrative Tools > Services. Right-click the Service Name and select Properties. Click the Log On tab. Retype the correct password. Start the the service....

Haven't tried but i think this will help

--Clearing Cache for SQL Server Performance Testing

USE ;

GO

CHECKPOINT;

GO

DBCC DROPCLEANBUFFERS;

GO

Production server: This is where live data is stored

Test Server: The server, you can use to test the application

Dev. server: The server where the actual development of the application takes...

check out all these links

You can Import the excel sheet as a table to a database using import and Export Wizard.

Also you can add the excel sheet as an linked server.

for this right...

No probzzzzz buddy any time

Check out this link:

In run type services.msc and start the sql server (MSSQLSERVER) make sure that this is set to Automatic. To avoid this problem in future.

See to It that all the sql...

To set your listening port go to Sql Server Configuration Manager->Protocals for MSSQLSERVER

ON the right double click on tcp/ip and the select IP Addresses , then enter 1433 where...

Problem is that your log file is 32 GB .

Try shrinking your log before you take backup

checkout this link

Depending on network speed and backlog of the SMTP server it may take time to deliver a Database mail. The you have to get your network people to troubleshoot the...