Environment: SQL Box: Windows Server 2008, SQL Server 2008 Std App Box: Windows Server 2008 I have one SQL and one App server. I've been asked to...
There are many unused databases in my DEV and QA environments. The space they take is about 700 MB. So, wouldn't be much saving in space if I drop...
Is there any estimate when Denali would be launched?
There is a stored procedure in one of DBs (and the DB size is about 70 GB) which is as below. SELECT ... FROM {Inner Join of 10 tables and views}...
I need to script everything related to a table except the table itself. I don't need CREATE TABLE but need to generate scripts for constraints, FKs,...
It's two years later.. Although we have Embarcadero tools but our DBA team decided to purchase another tool called SQL Sentry. It's great tool. Very...
Someone said: "If you do not have enough space in your dev environment to do a full restore, you will not be able to use backup and restore to...
I have a 1TB database that inherited. The database has 1 mdf file, 55 ndf, and 1 ldf. It is set to simple recovery mode. The database is on a SQL...
This is actually the auditors request and I don't undrestand what to do. See their request: Event Monitoring. We have reviewed EY's audit Wps for...
I want to see SQL Database and Network security event log settings. How can I do that?
I have a Scheduled batch file that copies BAK files from prod into DR box (in another country) every night starting at 8pm. There is a SQL job in DR...
It seems VERIFYONLY does not help my original question. I just started copying a BAK file into Test server and at the same time while the file was...
Thank you very much. I think RESTORE VERIFYONLY was what I was looking for. I'll test and if had any issue will post here. By the way, there is a...
During the night I have BAK file transfer to a Test machine and restore. The restore program fails when executes “RESTORE FILELISTONLY FROM DISK“...
I have a 10.5GB BAK file and I have to transfer it to another country every night. I thought to make it smaller. But actually, the reason I posted...
I know there are tools that squeeze SQL backup on the air. And I know SQL 2008 has the backup compression built in. But I am looking for a way to...
SQL Server 2k5 64bit version: 9.0.4035 I have a maintenance plan to delete BAK files older than 2 days. The job starts at 8:30pm everyday. But I see...
That was my mistake to write as [TempDB..T1]. I should have write TempDB..[T1] to make it work properly.
This is weird. This command SELECT * INTO [TempDB..T1] FROM [MyDB].[dbo].[T1] Creates a table in TEMPDB as “TempDB..T1â€!! This is the table...
Well you are right. That's laziness!! [:O] But it doesn't work any more.. Good lesson for me [8-|]
Separate names with a comma.
