Viewing 15 posts - 241 through 255 (of 405 total)
Original database must have contained unallocated space. Even though the data is only 2GB it will try to create the data and log file with original size specifications.
April 19, 2010 at 6:02 am
You must have a regular log backup in place that truncate inactive portions of the log.
You can use DBCC sqlperf('logspace') to find percent used for the log file
April 19, 2010 at 5:59 am
R u running trace? .
Then stop it
Select * from fn_trace_getinfo(null)
April 16, 2010 at 5:36 am
what is the lastwaitype in sysprocesses also take a not of hostname and program which is executing this query.
April 16, 2010 at 5:11 am
Sasidhar Pulivarthi (4/16/2010)
Eswar U r right....Its not possible. I installed on my local machine...I installed SQL 2008 & then installed SQL 2005, SQL 2005 it installed as SQL express....
Database...
April 16, 2010 at 4:41 am
You are not backing up. The above command truncate the log file without backing up.
April 16, 2010 at 4:38 am
Just find out what query is running and what resource it is waiting for. Its OK for a process to go suspended unless it does not wait for too long
April 16, 2010 at 4:35 am
You can use striped backup but its is sometimes risky
Backup database database name to disk='C:\backupfile_1.bak',disk='D:\backupfile_2.bak','E:\backupfile_3.bak
You need all these files for proper restore. Any corruption in single file can make the...
April 16, 2010 at 3:02 am
It might not be that easy but you can compare the features and create a template based on that. Few key concepts are resources supported, features available and budget.
April 10, 2010 at 1:24 am
If you have no issues with First node, (ie is ur first server is now acting as single node cluster), you are safe.
April 9, 2010 at 8:52 am
Did you read this link?
http://msdn.microsoft.com/en-us/library/ms191545(SQL.90).aspx
April 9, 2010 at 8:30 am
Not clear enough. Can you please tell what you are trying to achieve?
Are you trying to create a single node cluster?
April 9, 2010 at 8:07 am
If you put database in single user, and took the tail log backup, you might want to use the same window to execute further statements.
However you can use sysprocesses...
April 9, 2010 at 7:36 am
Use dm_db_index_usage_stats view to get some idea regarding this. Note: this view is flushed on each restart
April 9, 2010 at 7:25 am
Viewing 15 posts - 241 through 255 (of 405 total)