Hello,

Can you script out the entire syntax with respect to the database backup from the Idera SQLSafe tool and then execute the same from New Query Window?

You might get a...

Hello,

While executing the data query itself, you can export the data to a file as follows:

Click on Tools -> Options

Select Results tab and then select the option Results to File...

Hello,

You can restore the database with the backup file you have. Note down the drive location where you are restoring this database to. Now detach the database and overwrite the...

Hello John,

You can script out each object in the database as follows from Enterprise Manager: Go to the specific SQL Server

1. Right mouse click on any existing database and select...

Hello Smith,

Can you check whether this query gives out the desired results you want?

select

es.session_id, sp.spid,

Hello David,

You can use For..each look task in SSIS. You can go through this link

http://www.sqlis.com

This is a good resource.

Hope this helps.

Thanks

Hello Sridhar,

If the message says that the table doesn't exist then it might have been deleted. Otherwise, check the sysobjects in tempdb database as all the temporary objects will be...

Hello David,

First take a full backup with the name you desired. Now you restore back the backed-up database with the name desired and here you can change the file names.

Hope this...

Hello,

It seems your logins might have been orphaned. Whenever you restore a database from one server to another server, there might or might not exist all the logins that have...

Hello,

As you have mentioned that you have taken a transaction log backup, do take a full backup before and after shrinking the log file, which might free up the space...

Hello Dinesh,

I think the best way to proceed with your task is to

1. Remove the existing indexes

2. Update your 15 million records

3. Create the indexes

Hope this helps.

Thanks

Hello,

It seems there is no space on the disk to which you are trying to restore the database. Either you need to make up some space by deleting un-wanted files...

Hello,

You can't assign a variable to the base "CREATE" statement. You need to construct a dynamic SQL query to have the desired result as follows:

Declare @StrSQL varchar(8000)

SET @StrSQL = 'CREATE...

Hello Jeremy,

Yes you are on the right path.

Make sure that you are not upgrading a named instance, because if you upgrade the named instance and you have the name as "SQLEval",...

Hello Chad,

Can you try by interchanging the MOVE statements. First, give the .mdf statement and then .ndf statements. I think that it is trying to find the Primary filegroup and...