Hi,

First you need to create a Tape device on your system. Something like below:

EXEC sp_addumpdevice 'tape', 'tapedump1', '\\.\TAPE0';

Note: If you add a tape device, the parameter must be the physical...

Hi,

First you need to create a Tape device on your system. Something like below:

EXEC sp_addumpdevice 'tape', 'tapedump1', '\\.\TAPE0';

Note: If you add a tape device, the parameter must be the physical...

Hi,

First you need to create a Tape device on your system. Something like below:

EXEC sp_addumpdevice 'tape', 'tapedump1', '\\.\TAPE0';

Note: If you add a tape device, the parameter must be the physical...

Hi,

First you need to create a Tape device on your system. Something like below:

EXEC sp_addumpdevice 'tape', 'tapedump1', '\\.\TAPE0';

Note: If you add a tape device, the parameter must be the physical...

Hi,

You can go through this link for more information on the issue and analyse the workaround

http://msdn.microsoft.com/en-us/library/ms179984.aspx

Your question is not clear. Which memory you are talking about ? Is the Disk Memory is full? If the disk space is full, you need to delete the old...

You can know all about BI from Microsoft Online Books for SQL Server.

Check this URL:

http://www.microsoft.com/sqlserver/2005/en/us/business-intelligence.aspx

It has all about BI, WebCasts, Dev Materials, etc for your reference.

One can use...

The sp_updatestat runs in exculsive mode and scans all the user tables.

So there are possibilities of blocks. Run the sp_updatestat in offpeak hours to minimize the negative impact.

What error message you are getting while trying to restore the file ? Also mention the steps you have followed for restoration.

Hi,

First of all you need to unzip the file using Winzip or other tools and then try to restore the extratced BAK file.

The restore process is same in SQL Server...

Hi Ranjit,

The restoration of your deleted table depends upon the multiple points. Hope your database is in Full Recovery mode. If it is in simple recovery mode, the chances of...

Nice to hear this. Cheers.:-)

Check this for RESTORE DB options:

http://technet.microsoft.com/en-us/library/ms186858.aspx

While restoration you need to provide the DB name. Without providing the DB name, restoration can't be done.

In case you don't know which backup file belongs to which database, you...

There are many ways to take the backup of user databases. Use can create a script and job to take the backup. Just change the db name in the script...