Viewing 15 posts - 121 through 135 (of 168 total)
BOL is the best place to check doubts like yours.
Even in sql server central you will find article for this.
December 2, 2005 at 1:25 pm
Taskpad view gets data from sysfiles
Select CONVERT(VARCHAR(12),getdate(),111),Name,Size,FileName from Pubs.dbo.sysfiles
December 2, 2005 at 1:20 pm
Before Detach, have you executed any queries to see for sure database was
up and running. Why I am saying this is 'I think the backup was good'
mean you are not...
December 1, 2005 at 2:05 pm
It is safe to cancel at any time.
It works as single transaction, probably it can take some time for cancellation as well.
December 1, 2005 at 1:53 pm
Welcome to sql server community.
Here are few sites from where you can get good articles to add to your knowledge.
http://www.sqlservercentral.com
http://www.sql-server-performance.com/
http://www.databasejournal.com
vyaskn.tripod.com
Hope this helps
December 1, 2005 at 1:27 pm
Detach DB Fileà Copy File à Attach DB File
This option is always available, but this is...
December 1, 2005 at 12:47 pm
In sql2005 size specifications are
Database size 1,048,516 TB
File size (db) 32 TB and file size (log) 32 TB
so you do not need to increase the size, probably you are having...
December 1, 2005 at 12:29 pm
A maintenance plan does not overwrite the old backup file. It creates a new backup file, and then deletes the old backup file after creating the new one....
December 1, 2005 at 9:43 am
Sarang Bobde,
This is very interesting solution , but works only if you have rights for Enterprise manager.
your statement quoted above is misleading ,
November 30, 2005 at 3:09 pm
Instead of NoINIT try INIT option
this will initialize the backup file everytime it writes to backup file.
DUMP DATABASE <databasename> to <databasenamebackup> WITH NOUNLOAD, STATS=10, INIT, NOSKIP
November 30, 2005 at 3:05 pm
declare @sSQLMaintSwitchString nvarchar(4000)
set @sSQLMaintSwitchString =
N' -D "DatabaseName"' +
November 30, 2005 at 2:59 pm
It Will be good , if you can specify size of your db,giant will not
help here to suggest exact solution.
you can create few DTS packages to copy data from production db...
November 30, 2005 at 2:50 pm
Fallen Angel,
For sure this has nothing to do with previous thread.
Whatever I have to say, was said up front on that thread.
Even I don't think there is any sort of...
November 28, 2005 at 12:50 pm
try
DBCC ERRORLOG
Microsoft recommends using this over Sp_Cycle_ErrorLog
November 28, 2005 at 7:24 am
Bogus resumes and unblushing lies is good article, and I totally agree with Steve and
all of you except fallen...
November 23, 2005 at 2:13 pm
Viewing 15 posts - 121 through 135 (of 168 total)